<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en">
  <title id="ey142834">gp_distribution_policy</title>
  <body>
    <p>The <codeph>gp_distribution_policy</codeph> table contains information about Greenplum
      Database tables and their policy for distributing table data across the segments. This table
      is populated only on the master. This table is not globally shared, meaning each database has
      its own copy of this table.</p>
    <table id="ey142842">
      <title>pg_catalog.gp_distribution_policy</title>
      <tgroup cols="4">
        <colspec colnum="1" colname="col1" colwidth="106.5pt"/>
        <colspec colnum="2" colname="col2" colwidth="65.25pt"/>
        <colspec colnum="3" colname="col3" colwidth="105.75pt"/>
        <colspec colnum="4" colname="col4" colwidth="147pt"/>
        <thead>
          <row>
            <entry colname="col1">column</entry>
            <entry colname="col2">type</entry>
            <entry colname="col3">references</entry>
            <entry colname="col4">description</entry>
          </row>
        </thead>
        <tbody>
          <row>
            <entry colname="col1">
              <codeph>localoid</codeph>
            </entry>
            <entry colname="col2">oid</entry>
            <entry colname="col3">pg_class.oid</entry>
            <entry colname="col4">The table object identifier (OID).</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>policytype</codeph>
            </entry>
            <entry colname="col2">char</entry>
            <entry colname="col3"/>
            <entry colname="col4">The table distribution policy:<ul id="ul_a52_yj2_4gb">
                <li><codeph>p</codeph> - Partitioned policy. Table data is distributed among segment
                  instances. </li>
                <li><codeph>r</codeph> - Replicated policy. Table data is replicated on each segment
                  instance. </li>
              </ul></entry>
          </row>
          <row>
            <entry colname="col1"><codeph>numsegments</codeph></entry>
            <entry colname="col2">integer</entry>
            <entry colname="col3"/>
            <entry colname="col4">The number of segment instances on which the table data is
              distributed.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>distkey</codeph>
            </entry>
            <entry colname="col2">int2vector</entry>
            <entry colname="col3">pg_attribute.attnum</entry>
            <entry colname="col4">The column number(s) of the distribution column(s).</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>distclass</codeph>
            </entry>
            <entry colname="col2">oidvector</entry>
            <entry colname="col3">pg_opclass.oid</entry>
            <entry colname="col4">The operator class identifier(s) of the distribution
              column(s).</entry>
          </row>
        </tbody>
      </tgroup>
    </table>
  </body>
</topic>
